package com.jiuyun.dao;

import com.jiuyun.entity.*;

import java.sql.SQLException;
import java.util.List;

public interface StudentaDao {
    //查询所有
    List<Studenta> getAll() throws SQLException;

    int getadd(Studenta s) throws  SQLException;

    int getdel(int id) throws  SQLException;

    public int update(int calssa, String name, String pass, String sex, int id) throws SQLException;

    List<Studenta> getatAll(int sid) throws SQLException;
//-------------------------------班级dao-----------------------------------------------------

    List<Classa> banjiAll() throws  SQLException;

    int banjiadd(Classa c) throws  SQLException;

    int banjidel(int id)throws SQLException;

    public int updatebanji(String className, String classCreate, String classRemark, int classState, int bzr,int classid) throws SQLException;

    List<Classa> banjitjAll(int cid) throws  SQLException;

    //----------------------------------------laoshu------------------------------------------------------
    List<Teachar> laoshuAll() throws SQLException;

    int laoshuadd(Teachar t)throws  SQLException;

    int laoshudel(int id)throws  SQLException;

    public int updatelaoshu(String tname, String tpass, String tphone, String tjob, int teacharid)throws SQLException;

    List<Teachar> laoshutjAll(int tid)throws SQLException;

  //---------------------------------------------------------------------------------------------------------
    PerUser glydenglu(String name, String pass)throws  SQLException;

    Studenta xxdenglu(String name,String pass)throws SQLException;

    Teachar laoshidenglu(String name,String pass)throws  SQLException;






    List<Userrole> quanxian() throws SQLException;

    List<Userrole> denglu(String name,String pass) throws  SQLException;

    int zhuce(User u)throws SQLException;

    Userrole grxx(int uid) throws  SQLException;

}
